package com.ctshk.rpc.custom.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ctshk.rpc.custom.entity.CustomizedTripScheduleAmountStatistics;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 * 团期金额统计 Mapper 接口
 * </p>
 *
 * @author 叶冠峰
 * @since 2021-03-12
 */
public interface CustomizedTripScheduleAmountStatisticsMapper extends BaseMapper<CustomizedTripScheduleAmountStatistics> {

    /**
     * 根据团期id获取
     */
    @Select("SELECT * \n" +
            "FROM t_customized_trip_schedule_amount_statistics\n" +
            "WHERE schedule_id = #{schedule_id} AND is_deleted = 0 LIMIT 1 ")
    CustomizedTripScheduleAmountStatistics queryBySchedule(@Param("schedule_id") Long schedule);

}
